﻿<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="deliveryreport2.aspx.vb" Inherits="delivery_deliveryreport2" %>

<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ErrorContent" Runat="Server">
    <asp:ValidationSummary ID="ValidationSummary1" runat="server" />
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
          <ContentTemplate>
            <asp:ScriptManager ID="ScriptManager1" runat="server">
                </asp:ScriptManager>
              <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" Height="700px" WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="106%">
                  <localreport reportpath="delivery\Report3.rdlc">
                      <datasources>
                          <rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="DataSet1" />
                      </datasources>
                  </localreport>
              </rsweb:ReportViewer>

              <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" SelectCommand="SELECT dKey, serial, storename, storeip, guestname, guestaddress, contactno, order_, totalbill, specialins, changefor, status, datesent, datedelivered, timestamp, sender FROM delivery_items WHERE (timestamp BETWEEN @startDate AND @endDate)">
                  <SelectParameters>
                      <asp:QueryStringParameter Name="startDate" QueryStringField="start" />
                      <asp:QueryStringParameter Name="endDate" QueryStringField="end" />
                  </SelectParameters>
              </asp:SqlDataSource>

          </ContentTemplate> 
        </asp:UpdatePanel> 
</asp:Content>

